home *** CD-ROM | disk | FTP | other *** search
- <HTML>
- <HEAD>
- <LINK REL="stylesheet" TYPE="text/css" HREF="%6css/default.css">
- </HEAD>
-
- <BODY onLoad="init()" LEFTMARGIN="5" RIGHTMARGIN="5">
-
- <DIV ID="tooltip" STYLE="position:absolute;visibility:hidden;z-index:99;"></DIV>
-
- <SCRIPT SRC="%6js/helps.js"></SCRIPT>
- <SCRIPT SRC="%6js/tips.js"></SCRIPT>
-
- <SCRIPT language="JavaScript">
-
- function init()
- {
- if (document.rptDBLogon.DS.length > 0)
- {
- document.rptDBLogon.DS.options[0].selected = true;
- changeDataSource();
- }
-
- return true;
- }
-
- function DBInfo( dsName, dbType, dbTypeCustom, db, logonName, password, promptRunTime,
- useDefault, defaultServer, defaultDB, defaultUser, defaultPassword, isOLAP)
- {
- this.dsName = dsName;
- this.db = db;
- this.dbType = dbType;
- this.dbTypeCustom = dbTypeCustom;
- this.logonName = logonName;
- this.password = password;
- this.promptRunTime = promptRunTime;
- this.useDefault = useDefault;
- this.defaultServer = defaultServer;
- this.defaultDB = defaultDB;
- this.defaultUser = defaultUser;
- this.defaultPassword = defaultPassword;
- this.isOLAP = isOLAP;
- }
-
- var _numItems = %3;
- var currentItem;
- var dbInfoArray = new Array(_numItems);
-
- %4
-
- function changeDataSource()
- {
- list = document.rptDBLogon.DS;
- if (list.selectedIndex >= 0)
- {
- currentItem = list.selectedIndex;
- var dbInfo = dbInfoArray[currentItem];
-
- document.rptDBLogon.usedefdb.checked = dbInfo.useDefault;
- if ( dbInfo.useDefault )
- document.rptDBLogon.usedefdb[0].checked = true;
- else
- document.rptDBLogon.usedefdb[1].checked = true;
- document.rptDBLogon.DBS.value = dbInfo.dsName;
- document.rptDBLogon.DB.value = dbInfo.db;
- document.rptDBLogon.USR.value = dbInfo.logonName;
- document.rptDBLogon.PWD.value = dbInfo.password;
- document.rptDBLogon.PRT.checked = dbInfo.promptRunTime;
- document.rptDBLogon.defserver.value = dbInfo.defaultServer;
- document.rptDBLogon.defdatabase.value = dbInfo.defaultDB;
- document.rptDBLogon.defuser.value = dbInfo.defaultUser;
- document.rptDBLogon.defpassword.value = dbInfo.defaultPassword;
-
- document.rptDBLogon.customdbdriver.value = "";
-
- var i;
- for ( i = 0; i < document.rptDBLogon.dbdriver.options.length; i++)
- {
- if ( document.rptDBLogon.dbdriver.options[i].value == dbInfo.dbType )
- {
- document.rptDBLogon.dbdriver.selectedIndex = i;
- break;
- }
- }
-
- if ( i < document.rptDBLogon.dbdriver.options.length )
- {
- document.rptDBLogon.radiodbdriver[0].checked = true;
- }
- else
- {
- document.rptDBLogon.radiodbdriver[1].checked = true;
- document.rptDBLogon.customdbdriver.value = dbInfo.dbTypeCustom;
- }
-
- changeDefaultDB();
- }
- }
-
- function changeDefaultDB()
- {
- var dbInfo = dbInfoArray[currentItem];
- var isOLAP = dbInfo.isOLAP;
- var isUsingDefault = ( (document.rptDBLogon.usedefdb[0].checked == true) || isOLAP);
-
- dbInfo.useDefault = isUsingDefault;
-
- document.rptDBLogon.usedefdb[1].disabled = isOLAP;
-
- document.rptDBLogon.defuser.disabled = !isUsingDefault;
- document.rptDBLogon.defpassword.disabled = !isUsingDefault;
-
- document.rptDBLogon.dbdriver.disabled = isUsingDefault;
- document.rptDBLogon.DBS.disabled = isUsingDefault;
- document.rptDBLogon.DB.disabled = isUsingDefault;
- document.rptDBLogon.USR.disabled = isUsingDefault;
- document.rptDBLogon.PWD.disabled = isUsingDefault;
- document.rptDBLogon.radiodbdriver[0].disabled = isUsingDefault;
- document.rptDBLogon.radiodbdriver[1].disabled = isUsingDefault;
- document.rptDBLogon.customdbdriver.disabled = isUsingDefault;
-
- changeDriver();
- }
-
- function removeNSFocus( condition )
- {
- // Netscape Navigator 4 doesn't support the disabled property for text input fields
- if ( condition )
- if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) <= 4))
- document.rptDBLogon.DS.focus();
- }
-
- function focustDefUserOrPwd()
- {
- removeNSFocus( document.rptDBLogon.usedefdb[1].checked );
- }
-
- function focusInput()
- {
- removeNSFocus( document.rptDBLogon.usedefdb[0].checked );
- }
-
- function focusDBTypeSelect()
- {
- removeNSFocus( document.rptDBLogon.usedefdb[0].checked || document.rptDBLogon.radiodbdriver[1].checked );
- }
-
- function focusDBTypeCustom()
- {
- removeNSFocus( document.rptDBLogon.usedefdb[0].checked || document.rptDBLogon.radiodbdriver[0].checked );
- }
-
- function changeDefaultUser()
- {
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.defaultUser = document.rptDBLogon.defuser.value;
- }
-
- function changeDefaultPwd()
- {
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.defaultPassword = document.rptDBLogon.defpassword.value;
- }
-
- function changeDriver()
- {
- if ( document.rptDBLogon.radiodbdriver[0].checked )
- changeDriverSelect();
- else
- changeDriverText();
- }
-
- function changeDriverSelect()
- {
- if ( document.rptDBLogon.usedefdb[1].checked )
- {
- document.rptDBLogon.customdbdriver.disabled = true;
- document.rptDBLogon.dbdriver.disabled = false;
- }
-
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.dbType = document.rptDBLogon.dbdriver[document.rptDBLogon.dbdriver.selectedIndex].value;
- }
-
- function changeDriverText()
- {
- if ( document.rptDBLogon.usedefdb[1].checked )
- {
- document.rptDBLogon.customdbdriver.disabled = false;
- document.rptDBLogon.dbdriver.disabled = true;
- }
-
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.dbType = 1000;
- dbInfo.dbTypeCustom = document.rptDBLogon.customdbdriver.value;
- }
-
- function changeServer()
- {
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.dsName = document.rptDBLogon.DBS.value;
- }
-
- function changeDB()
- {
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.db = document.rptDBLogon.DB.value;
- }
-
- function changeLogonName()
- {
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.logonName = document.rptDBLogon.USR.value;
- }
-
- function changePassword()
- {
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.password = document.rptDBLogon.PWD.value;
- }
-
- function changeRunTime()
- {
- var dbInfo = dbInfoArray[currentItem];
- dbInfo.promptRunTime = document.rptDBLogon.PRT.checked;
- }
-
- function updateDBSource()
- {
- for (var i = 0; i < _numItems; i++)
- {
- var list = document.rptDBLogon.DS;
- var dbInfo = dbInfoArray[i];
-
- document.rptDBLogon.elements["dbtype" + i].value = dbInfo.dbType;
- document.rptDBLogon.elements["dbtypecustom" + i].value = dbInfo.dbTypeCustom;
- document.rptDBLogon.elements["dbserver" + i].value = dbInfo.dsName;
- document.rptDBLogon.elements["db" + i].value = dbInfo.db;
- document.rptDBLogon.elements["logon" + i].value = dbInfo.logonName;
- document.rptDBLogon.elements["pwd" + i].value = dbInfo.password;
- document.rptDBLogon.elements["pvt" +i].value = dbInfo.promptRunTime;
- document.rptDBLogon.elements["usedefault" + i].value = dbInfo.useDefault;
- document.rptDBLogon.elements["dbdefaultuser" + i].value = dbInfo.defaultUser;
- document.rptDBLogon.elements["dbdefaultpwd" + i].value = dbInfo.defaultPassword;
- }
-
- document.forms.rptDBLogon.submit();
- }
-
- </SCRIPT>
-
- <FORM name="rptDBLogon" method=POST action="%2">
- <input type="hidden" name="dbnum" value="%3">
- <SPAN CLASS="listSelected">Set the default information for logging onto the data source(s) automatically whenever the report is run.</SPAN><BR>
- <BR>
- <TABLE border="0" cellpadding="5" cellspacing="5">
- <TR>
- <TD class="list" valign="top">
- Data Source(s):<BR>
- <SELECT class="menuFormElement" SIZE="12" NAME="DS" onchange="changeDataSource()">
-
- %1
-
- </SELECT>
- </TD>
- <TD class="list" VALIGN="top">
- <BR>
- <TABLE border="0" cellpadding="0" cellspacing="0">
- <TR>
- <TD class="list" valign="top"><INPUT TYPE="radio" NAME="usedefdb" onclick="changeDefaultDB()" value="true"> </TD>
- <TD class="list" valign="top" colspan=4>Use original database logon information from the report</TD>
- </TR>
- <TR>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="middle" nowrap>Server: </TD>
- <TD class="list" colspan=2 valign="top"><INPUT name="defserver" size=40 onChange="changeDefaultUser()" onfocus="removeNSFocus(true);" disabled></TD>
- </TR>
- <TR>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="middle" nowrap>Database: </TD>
- <TD class="list" colspan=2 valign="top"><INPUT name="defdatabase" size=40 onChange="changeDefaultUser()" onfocus="removeNSFocus(true);" disabled></TD>
- </TR>
- <TR>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="middle" nowrap>User: </TD>
- <TD class="list" colspan=2 valign="top"><INPUT name="defuser" size=40 onChange="changeDefaultUser()"></TD>
- </TR>
- <TR>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="middle" nowrap>Password: </TD>
- <TD class="list" colspan=2 valign="top"><INPUT name="defpassword" type="password" size=40 onChange="changeDefaultPwd()"></TD>
- </TR>
- <TR>
- <TD class="list" colspan=5 valign="top"> </TD>
- </TR>
- <TR>
- <TD class="list" valign="top"><INPUT TYPE="radio" NAME="usedefdb" onclick="changeDefaultDB()" value="false"> </TD>
- <TD class="list" valign="top" colspan=4>Use custom database logon information specified here</TD>
- </TR>
- <TR>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="top"> </TD>
- <TD class="list" valign="top" nowrap> Database Type:</TD>
- <TD class="list" valign="top"><INPUT TYPE="radio" NAME="radiodbdriver" value="false" onfocus="focusInput()" onclick="changeDriver();"> </TD>
- <TD class="list" nowrap>Select a database driver</TD>
- </TR>
- <TR>
- <TD class="list" colspan=4> </TD>
- <TD class="list"><SELECT class="menuFormElement" size="1" name="dbdriver" onfocus="focusDBTypeSelect()" onchange="changeDriverSelect();">
- <OPTION name="ODBC" value="1" selected>ODBC</OPTION>
- <OPTION name="ORACLE" value="2">Oracle</OPTION>
- <OPTION name="DB2" value="3">DB2</OPTION>
- <OPTION name="SYBASE" value="4">Sybase</OPTION>
- <OPTION name="INFORMIX" value="5">Informix</OPTION>
- <OPTION name="SQL" value="6">SQL Server</OPTION>
- </SELECT>
- </TD>
- </TR>
- <TR>
- <TD class="list" colspan=3></TD>
- <TD class="list"><INPUT type="radio" name="radiodbdriver" value="true" onfocus="focusInput()" onclick="changeDriver();"> </TD>
- <TD class="list" nowrap>Specify a custom driver</TD>
- </TR>
- <TR>
- <TD class="list" colspan=4> </TD>
- <TD class="list"><INPUT name="customdbdriver" size=36 onfocus="focusDBTypeCustom()" onchange="changeDriverText();"></TD>
- </TR>
- <TR>
- <TD class="list" colspan=5 valign="top"> </TD>
- </TR>
- <TR>
- <TD class="list" colspan=2> </TD>
- <TD class="list" valign="middle"> Server: </TD>
- <TD class="list" valign="middle" colspan=2><INPUT NAME="DBS" SIZE="40" onfocus="focusInput()" onchange="changeServer();"></TD>
- </TR>
- <TR>
- <TD class="list" colspan=2> </TD>
- <TD class="list" valign="middle"> Database: </TD>
- <TD class="list" valign="middle" colspan=2><INPUT NAME="DB" SIZE="40" onfocus="focusInput()" onchange="changeDB();"></TD>
- </TR>
- <TR>
- <TD class="list" colspan=2> </TD>
- <TD class="list" valign="middle"> User: </TD>
- <TD class="list" valign="middle" colspan=2><INPUT NAME="USR" SIZE="40" onfocus="focusInput()" onchange="changeLogonName()"></TD>
- </TR>
- <TR>
- <TD class="list" colspan=2> </TD>
- <TD class="list" valign="middle"> Password: </TD>
- <TD class="list" valign="middle" colspan=2><INPUT TYPE="password" NAME="PWD" SIZE="40" onfocus="focusInput()" onchange="changePassword()"></TD>
- </TR>
- <TR>
- <TD class="list" colspan=5 valign="top"> </TD>
- </TR>
- </TABLE>
- <INPUT TYPE="checkbox" NAME="PRT" onclick="changeRunTime()"> Prompt the user for database logon when viewing<BR>
- </TD>
- </TR>
- <TR>
- <td align="right" colspan="2">
- <BR>
- <table border=0 cellpadding=0>
- <tr valign="middle">
- <td class="clsButton" align=middle nowrap>
- <div class="clsButton"><a href="javascript:updateDBSource();" onMouseOver="St(7);window.status='';return true;" onMouseOut="Ht()">Update</a></div>
- </td>
- <td class="clsButton" align=middle nowrap>
- <div class="clsButton"><a href="%5" onMouseOver="St(8);window.status='';return true;" onMouseOut="Ht()">Reset</a></div>
- </td>
- </tr>
- </table>
- </td>
- </TR>
- </TABLE>
-
- %7
-
- </FORM>
-
-
- </BODY>
- </HTML>
-